<%-- 
    Document   : prosespendaftaran
    Created on : Nov 10, 2012, 2:58:07 PM
    Author     : yolan
--%>
<%
            bean.koneksi conn = new bean.koneksi();
%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>PSB SMA N 1 Yogyakarta</title>
    </head>
    <style>
        #main{
            font-weight: bold;
            padding-left:0px;
            padding-right:0px;
            margin-top: 0px;
            margin-left:170px;
            margin-right:170px;
            margin-bottom:0px;
        }

        #menuhor{
            list-style-type: disc;
            margin: 0;
            padding: 0;

            float: left;
        }
        #menuhor li {
            margin: 0;
            padding: 0 ;
            float: left;

        }
        #menuhor a {
            float: none;
            width: 150px;
            text-align: center;
            color: #FFF;
            text-decoration: none;
            padding: 2px;
            line-height: 2;
            margin-bottom: 3px;
        }
        #menuhor a:hover{
            background: brown;
        }
    </style>
     <jsp:useBean id="input" scope="session" class="bean.Siswa"/>
    <jsp:setProperty name="input" property="*" />

   <body bgcolor="grey">

        <div id="main">
            <img alt="cover" src="gambar/tes.jpg" width="1000" height="200">
           
            <br>
            </body>
             
        <div id="java">
                <H1><font color="red">Konfirmasi</font></H1>
                    <%
                     java.sql.Statement statement = conn.getConnection().createStatement();
                    java.sql.ResultSet result2 = null;
                                try {
                                    String query = "insert into pendaftaran(nama,alamat,asalsekolah,tanggallahir,jeniskelamin,agama,nis,nem)  values "
                                            + "('" + request.getParameter("nama") + "' , '" + request.getParameter("alamat") + "' , '" + request.getParameter("asalsekolah")
                                            + "' , '" + request.getParameter("tanggallahir") + "' , '" + request.getParameter("jeniskelamin") + "' , '" + request.getParameter("agama")
                                            + "' , '" + request.getParameter("nis") + "' , '" + request.getParameter("nem") + "')";
                                   
                                    int s = statement.executeUpdate(query);

                                    System.out.println("Data berhasil dimasukkan \n");

                                    
                                    statement.close();
                                } catch (Exception ex) {
                                    out.println("message: " + ex.getMessage());
                                                                                                            
                                }
                  

                    %>
                    <font color="yellow">         Nama      : <jsp:getProperty name="input" property="nama" /><br>
                                                  Alamat    : <jsp:getProperty name="input" property="alamat" /><br>
                                                  Asal Sekolah  : <jsp:getProperty name="input" property="asalsekolah" /><br>
                                                  Tanggal Lahir : <jsp:getProperty name="input" property="tanggallahir" /><br>
                                                  Jenis Kelamin : <jsp:getProperty name="input" property="jeniskelamin" /><br>
                                                  Agama : <jsp:getProperty name="input" property="agama" /><br>
                                                  NIS   : <jsp:getProperty name="input" property="nis" /><br>
                                                  NEM   : <jsp:getProperty name="input" property="nem" /><br>
                                                    
                                                  
                                                   
                    
                                                  <br><br><br><br>
                                                  <blink> <font color="red">Terima Kasih Anda Sudah Terdaftar ...<br>  </blink>     
                                                  <font style="color: white ;font-size: 14px" >Untuk melihat jurnal nilai klik : 
                                                  <a href="jurnal.jsp"> Jurnal Nilai </a> </font>
                
            </div
        </div>
</html>
